SAS Visual Analytics reports that are viewed inside Microsoft Excel might refresh incompletely when they are refreshed as a scheduled task. This problem is most likely to occur for complex reports that have large results. The problem occurs when the Save operation is called before the Refresh action is fully finished.

As a workaround, you can manually edit the VBS script that is created during the schedule process. The default location for the script is Documents\My SAS Files\Add-In for Microsoft Office. In the VBS file, find the following line:

Just before this line, add the following line:

This change delays the Save operation for 10 seconds, which should allow enough time for the report to finish rendering.

Operating System and Release Information